About SQL syntax
The SQL Queries operator enables you to return a value that meets specific conditions. Within the Select From Where expression, you enter the fields, functions, and constants.
When building an SQL expression, you can use any mathematical or relational operations, as well as language operators. The placement of operators is critical to proper calculation, and some operators are placed before rather than after the fields. The following list describes the language operators you can use in an SQL expression:
|
Operator |
Description |
|---|---|
|
Select |
Locates data for the selected field. |
|
Select Sum |
Locates and totals all figures for the selected field. You can use Select Sum in place of the Select portion of the expression. |
|
From |
Indicates the source database. Usually follows the Select portion of the expression. |
|
Where |
Defines the criteria that data must meet for use in the query. Usually follows the From portion of the expression. |
|
Between |
Defines a range of data. The Between operator works similar to >= and <=. |
|
Inner Join |
Creates a relationship between two tables. |
Example: Syntax
Syntax: Select table1 From table2 Where value
- Table1 is the data you want to select.
- Table2 is the table from which you want to select the data.
- Value is the value for which the SQL function is searching.
Important! The syntax for an SQL expression can vary greatly depending on the complexity. The syntax above only outlines a simple SQL expression.
Example:
If you store information in the user-defined fields in 7-1 Company Information, you can use an SQL query to extract the information.
Syntax: Select USRDF1 From CMPANY
Queries follow these specific guidelines:
- Brackets [ ] let you create separate SQL expressions and perform mathematical operations on them.
- In the query expression, you can use the equal to (=), greater than (>), or less than (<) signs to test for a value returned by the field.
- Use mathematical operators such as addition (+), subtraction (–), multiplication (*), or division (/) between two or more SQL queries to create a single expression. Use the operators to combine two or more embedded queries.